/**
 * 
 */
package com.xintoucloud.gsv.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.xintoucloud.gsv.entity.SupervisionType;

/**
 * @author xiang
 *
 */
public interface SupervisionTypeMapper {
	
	@Select("select * from t_supervision_type")
	List<SupervisionType> listSupervisionType();
	
	@Insert("insert into t_supervision_type(sname,sdescribe) values(#{sname},#{sdescribe})")
	void addSupervisionType(SupervisionType supervisionType);

	@Delete("delete from t_supervision_type where sid=#{sid}")
	void deleteSupervisionType(int sid);
	
	@Update("update t_supervision_type set sname=#{sname},sdescribe=#{sdescribe} where sid=#{sid}")
	void updateSupervisionType(SupervisionType supervisionType);
	
	@Select("select * from t_supervision_type where sid=#{sid}")
	SupervisionType getSupervisionType(int sid);
}
